HA$PBExportHeader$u_sqlca.sru
forward
global type u_sqlca from transaction
end type
end forward

global type u_sqlca from transaction
end type
global u_sqlca u_sqlca

type prototypes
function long Usp_GetIdTabla(string tabla,ref string codigo) RPCFUNC ALIAS FOR "dbo.Usp_GetIdTabla"
function long Usp_GetCodigoDocVta(long tipoDoc,ref string Correlativo) RPCFUNC ALIAS FOR "dbo.Usp_GetCodigoDocVta"

function long Usp_GetIdTablaINT(string tTabla,ref long nCorrelativo) RPCFUNC ALIAS FOR "dbo.Usp_GetIdTablaINT"
function long Usp_AddMKARDEX_Venta(long documento) RPCFUNC ALIAS FOR "dbo.Usp_AddMKARDEX_Venta"

function long Usp_AddMKARDEX(long movimiento) RPCFUNC ALIAS FOR "dbo.Usp_AddMKARDEX"

function long Usp_GetStock_MITEM(long iditem,ref double nstock) RPCFUNC ALIAS FOR "dbo.Usp_GetStock_MITEM"
function long Usp_GetStockMITEMALMA(long iditem,long idalma,ref double nstock) RPCFUNC ALIAS FOR "dbo.Usp_GetStockMITEMALMA"

function long Usp_GetTDocumentoMMovimiento(long ntrans,string tIngSal,long nEmpresa,long nCentro,long nAlma,ref string codigo) RPCFUNC ALIAS FOR "dbo.Usp_GetTDocumentoMMovimiento"

function long Usp_Anular_MKARDEX(string tipo,long idmovidocu) RPCFUNC ALIAS FOR "dbo.Usp_Anular_MKARDEX"
function long Usp_UpdateMKARDEX(long idmovimiento) RPCFUNC ALIAS FOR "dbo.Usp_UpdateMKARDEX"

function long Usp_Recalcular_MKARDEX(long item,long alma,datetime desde,string cadena,long idempresa) RPCFUNC ALIAS FOR "dbo.Usp_Recalcular_MKARDEX"

function long Usp_Add_OSAC(long idOsac,string Usuarios,string tipo,string stat) RPCFUNC ALIAS FOR "dbo.Usp_Add_OSAC"

function long Usp_CargaAccesosUser(string modulo,string iduser) RPCFUNC ALIAS FOR "dbo.Usp_CargaAccesosUser"

function long Usp_Insert_Mosac(string user,string userDestino,string Asunto,string msj,string ticket) RPCFUNC ALIAS FOR "dbo.Usp_Insert_Mosac"
function long Usp_GetHostNameBD(ref string host) RPCFUNC ALIAS FOR "dbo.Usp_GetHostNameBD"
function long Usp_GetUserBD(ref string user) RPCFUNC ALIAS FOR "dbo.Usp_GetUserBD"


function long USP_GetPassword(string iduser,string tclave,ref string tPassword) RPCFUNC ALIAS FOR "dbo.USP_GetPassword"
function long USP_SetPassword(string iduser,string tclave,string tPassword) RPCFUNC ALIAS FOR "dbo.USP_SetPassword"
function long Usp_GetCorrelativoDocuVTa(string user,string serie,long idDocu,ref string Correlativo,ref long lntError,ref string StError) RPCFUNC ALIAS FOR "dbo.Usp_GetCorrelativoDocuVTa"

function long Usp_GetSerieDocuVta(string user,long idDocu,ref string serie) RPCFUNC ALIAS FOR "dbo.Usp_GetSerieDocuVta"

function long Usp_GetExistDocuVTa(long idDocu,string Correlativo,ref long IntError) RPCFUNC ALIAS FOR "dbo.Usp_GetExistDocuVTa"

function long Usp_GetDocuVtaStat(long idDocu,string Correlativo,ref string Stat) RPCFUNC ALIAS FOR "dbo.Usp_GetDocuVtaStat"

function long Usp_SetCorrelativoDocuVTa(string user,string serie,long idDocu,long Posicion) RPCFUNC ALIAS FOR "dbo.Usp_SetCorrelativoDocuVTa"
function long Usp_GetTipoCambio(datetime fecha,string tipo,ref double tc) RPCFUNC ALIAS FOR "dbo.Usp_GetTipoCambio"
function long Usp_GetExisteCorrelativoDocVta(long Posicion,long idDocu,string IdSerie,string IdUser,ref long IntError,ref string stError) RPCFUNC ALIAS FOR "dbo.Usp_GetExisteCorrelativoDocVta"
function long Usp_PrintMMovimiento(long idmovimiento,decimal{2} cantPrint) RPCFUNC ALIAS FOR "dbo.Usp_PrintMMovimiento"
function long Usp_AddMKARDEX_TRANSF(long movimiento) RPCFUNC ALIAS FOR "dbo.Usp_AddMKARDEX_TRANSF"
function long Usp_GetExisteMItemAlma(long iditem,long idalma,ref long nCount) RPCFUNC ALIAS FOR "dbo.Usp_GetExisteMItemAlma"
function long USP_OSAC_RepEstadistico_Tecnico(string iduser,datetime fini,datetime ffin,string tipo) RPCFUNC ALIAS FOR "dbo.USP_OSAC_RepEstadistico_Tecnico"
function long Usp_GetUserAlma(string iduser,long idalma,ref long idReturn) RPCFUNC ALIAS FOR "dbo.Usp_GetUserAlma"

function long Usp_GetPrecioItem(long iditem,long tipoPrecio,long idmoneda,ref double nporc1,ref long exoigv,ref double precioventa,ref long intreturn) RPCFUNC ALIAS FOR "dbo.Usp_GetPrecioItem"
function long Usp_GetValidarPrecio(long iditem,long idlista,long idmoneda,double precio,ref long Intreturn,ref string returnMsj) RPCFUNC ALIAS FOR "dbo.Usp_GetValidarPrecio"

function long Usp_GetIGV(datetime fecha,ref decimal{2} igvNew) RPCFUNC ALIAS FOR "dbo.Usp_GetIGV"


function long CONTA_Usp_GetComprobante(long EMPRESA,string EJERCICIO,string PERIODO,string SUBDIARIO,ref string COMPROBANTE) RPCFUNC ALIAS FOR "dbo.CONTA_Usp_GetComprobante"

function long CONTA_Usp_SetComprobante(string COMPROBANTE,long idRefe) RPCFUNC ALIAS FOR "dbo.CONTA_Usp_SetComprobante"


end prototypes

forward prototypes
public function integer uf_getcodigo ()
end prototypes

public function integer uf_getcodigo ();return 1
end function

on u_sqlca.create
call super::create
TriggerEvent( this, "constructor" )
end on

on u_sqlca.destroy
TriggerEvent( this, "destructor" )
call super::destroy
end on

